package com.javasm.crm.mapper.sell;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.javasm.crm.domin.vo.SellOrderDetailVO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Author：liuqizhe
 * @Version：1.0
 * @Date：2021/7/14-14:55
 * @Since:jdk1.8
 * @Description:TODO
 */
@Repository
public interface SellOrderDetailVOMapper extends BaseMapper<SellOrderDetailVO> {

    @Select("select o.*,s.order_state" +
            " from sell_order o,sell_state s" +
            " where o.sell_code = s.sell_code and o.sell_code = #{sellCode}")
    SellOrderDetailVO searchSellOrderDetailVO(@Param("sellCode") String sellCode);
}
